|
Using the Data Object Manager to manage loaded object data |
Data Object Manager
To access this dialog:
-
In the Loaded Data control bar, right-click an object, select Data Object Manager....
-
In the Sheets control bar, right-click an object, select Data Object Manager....
The Data Object Manager utility contains a host of functions that relate to the control and analysis of loaded object data.
The dialog has 3 main areas; select an item for more information:
-
Data Object Manager toolbar: this contains buttons which access object-related commands.
-
Loaded Data Objects list: displays all currently loaded (in-memory) objects, and is used to add a data column (property) to the selected object.
-
Data Object and Data Table tabs: the Data Object tab shows a summary of the selected object's statistics, object filtering and the associated data source; the Data Table tab shows a view of the contents of the selected object's database table.
Data Object Manager Toolbar
The following commands are available (listed from left to right on the toolbar):
Import Data: opens the Data Import dialog, which is used to bring data into your application, using the selected Data Source Driver (DSD).
Export Data: shows the Data Export dialog, allowing you to export the selected file using the specified DSD.
Refresh Data: refreshes (redraws) the currently selected object.
Refresh All Data: refreshes all currently listed objects.
Reload Data: reloads the selected object using the current saved state of the selected file, using the associated DSD.
Unload Data: remove the selected object from memory. Note that this does not remove the file from the project.
Combine Objects: displays the Combine Data Objects dialog. This dialog is used to join currently loaded objects together.
Extract From Object: select a property or properties of an object to extract. Displays the Extract Data Object dialog.
First Record: Move to the first record.
Previous Record: Move to the previous record.
Next Record: Move to the next record.
Last Record: Move to the last record.
Search: Find a specified value in the table.
Find Next: Find the next instance of that specified value.
Find Previous: Find the previous instance of that specified value.
Definition Viewer: view the data definition of the selected object; displays the Definition Viewer dialog.
Export to Excel: export the first 65536 rows of data to an installed Excel application.
It is not possible for block model objects to be used for extraction. The function is restricted to point, string and wireframe data only. |
Loaded Data Objects List
This area displays a list of all loaded objects. Expanding an object will show the components (data columns/fields) it is comprised of e.g.:
Selecting an object in the list will update the contents of the Data Object tab and the Data Table tab.
To add a property (data column/field) to an object:
-
Select an object in the Loaded Data Objects pane (providing it is not write-protected)
-
Right-click and select Add Column
-
In the Add Column dialog, define the parameters, click OK.
The Data Column list (shown when a Data Table menu is expanded) contains the following options:
- Delete: delete the selected attribute from the selected object, after confirmation.
- Set Conversions: specify how special values are converted when a data table is loaded into menu, using the Data Conversions dialog.
- [Field Name] properties: open the field properties dialog for the selected attribute.
Data Object tab
For information on the Data Table tab, click here... |
Field Details:
Object Name: the name of the currently selected object, with the data type shown in brackets after (e.g. 'MyFile (points)').
Description: a brief description of the selected object.
Long Description: a fuller description of the selected object including the full file path of the loaded file, the type of data represented, the number of database records associated with it and details of any filters applied during the data load process.
Time Stamp: if the loaded file has a time stamp, it is shown in this field.
Version Info: version information is shown here. If it is not found, a default version of '0.0.0' is applied.
Statistics: information relating to the structure of the data found within the file. For example, "129 points' (points file selected), '69037 full cells, 28220 subcells' (block model) etc.
Filter: use this field to define a filter expression for the selected object. Clicking Expression Builder... displays the Expression Builder dialog.
The filter expression displayed here applies only to the selected object, but can be the result of defining a filter using one of the following methods:
|
Store in project file: this check box is used to determine the selected data object is archived within the current project file, or is simply referenced by the project as a file on disk. In the latter case, the Data Source is relevant (see below).
Data
Source: this field shows the path that the selected object
data is derived from. You can click Save As...
to open the Save New 3D Object
dialog.
Drillholes, Object Filters, Columns and Column Filters
Drillhole data objects are often coupled with 'downhole column' data to provide more information about the drillhole data. This could be in the form of a histogram, listed grade values, braces, bar charts etc. Downhole columns are formatted separately (using the Format Column Display Dialog) from the actual drillhole data (which uses the Traces as Holes dialog).
View Filtering can be applied to any object in memory, including drillholes, to control the data that is displayed at any one time. This is controlled by a filter expression which can be defined by various methods to specifically filter drillhole data, using the filter-drillholes command.
Drillhole segments and downhole columns will always honor this object-level filter. If data does not pass the filter, neither it nor the associated downhole column data will be shown.
However, the situation is slightly more complex where a 'column-specific' filter exists. All downhole columns can be associated with their own filter (using the Filter tab on the Format Columns dialog). In this case, an aspect of the downhole column will only be shown if it passes both the object-level and column-level filters. For example; if a drillhole object was filtered in the Data Object Manager to only show data above the X value 150, only column and drillhole data would be shown above the 150 position. If an AU column was set to show results only where the grade surpasses the 1.0 grade cut-off point, downhole column data would only be shown above 150 in X and where grade values exceed 1.0 ppm.
Related Topics | |
| Objects
overview Data Export dialog Data Source Drivers overview Data Object Manager - Data Table Data Object Manager - Data Table Format |